AssetWise Implementation Guide

To Create an Integration Services Project in Visual Studio 2019

  1. Create an SSIS project on the computer where SSIS 2019 with "SQL Server Integration Services Projects" extension and AssetWise ALIM SSIS is installed:
    1. Open Visual Studio 2019 as an Administrator.
    2. Select File > New > Project.
    3. Browse to and select Integration Services Project, and then click Next.
    4. Enter a Project Name, and then click Create.
  2. Add a connection to the AssetWise ALIM data source:
    1. Right-click the Connection Managers section, and then select New Connection.
    2. In the dialog, select eB - Connection manager for eB, and then click Add.
    3. In the eB Connection Manager Editor, enter an ALIM Username, Password, Application Server name, and then select a data source.
  3. Add an Import Staged eB Data Task:
    1. Open SSIS Toolbox from Extensions > SSIS > SSIS Toolbox
    2. Drag and drop the Import Staged eB Data Task onto the Control Flow Window.
    3. Edit the task and set the required options:
      1. eBConnectionManager – Select the Connection Manager identified in Step 2
      2. Default Scope – Select the default scope to be used for the import
      3. ContextId – Select New Variable, and then enter a Name - Context and string value, for example, "10"
      4. Click OK to close and save the task.
  4. Click Start to run the Import Staged eB Data Task.
  5. Inspect the task run output from either the Progress or Execution Results tab.
Parent topic: AssetWise SSIS Components Configuration